<?php
class M_DbTable_TourStyle extends Apps_Db_Table_Abstract {
	protected $_name = 'tour_style';

	const STATUS_ACTIVE 	= 1;
	const STATUS_INACTIVE 	= 0;
	const STATUS_DELETED 	= -1;

	const SHOW_HOME         = 1;
	const NOT_SHOW_HOME     = 0;

	//LIST
	public function getList () {
		$q = $this->_db
				  ->select()
				  ->from($this->_name, null)
				  ->where('status =?', self::STATUS_ACTIVE)
				  ->order($this->_name . '.en_title')
				  ->columns(array('id'			    => 'id',
				 				  'title'		    => 'title',
				 				  'en_title'	    => 'en_title',
				 				  'description'	    => 'description',
				 				  'show_home'	    => 'show_home',
				 				  'sorting_number'	=> 'sorting_number',
				  				  'created_date'    => 'created_date'));
 		return $q;
	}
}